Model Table SHOP ORDER

Attributes

Attribute Description (where applicable)
SO Cust Order NoCorresponding customer order number for Shop Order.
SO Demand CodeDemand Code Description, type of demand.
SO Material StateStatus of material on shop order. Typically Completely Issued, Not Reserved etc.
SO Multilevel RepairIs the shop order repair a part of the as built stricture ? True/False.
SO Operation StateStatus of Operation on shop order. Typically Reported, Not Reported.
SO Order CodeDescribing type of Shop order. Assembly, Repair, Manufacturing etc.
SO Order NoShop order number.
SO Product StateStatus of products on Shop Order. Received, Not Received etc.
SO StateStatus of shop order. Planned, Finished Closed etc.
SO Used Struc BOM TypeBill of Material Structure type used to build the shop order.
Shop OrderBuilt up as OrderNo - ReleaseNo - SeqNo.

USED BY MODEL(S)

Model Name
Production Performance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
SHOP ORDERFACT_SHOP_ORDER_TMFACT_SHOP_ORDER_BIFACT_SHOP_ORDERData Mart